package net.jsoft.pms.mapperwtglpt.problems;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Component;

@Mapper
@Component("problemMapper")
public interface ProblemMapper
{
    @Select("select SJBM id,SJBT title,xxms content, tjsj insertDate , jjcdmc  ,'1' status , clgwmc dept, clrmc optPerson ,yjxfkssj,YJXFSJ from BZ_SJ_SJXX where clgwmc in ('1101_电子税务局_局端系统_电子报税','1102_电子税务局_局端系统_在线办税','1103_电子税务局_局端系统_信息服务') and sjzt_dm in ('03','02') ")
    List<Map<String, Object>> findProblems();
}
